//判断账号/密码是否输入正确public void OnMyLoginClick(View v){ EditText name=(EditText)findViewById(R.id.editText2); EditText pwd=(EditText)findViewById(R.id.editText4); //调用DBOpenHelper (user.db是创建的数据库的名称) DBOpenHelper helper = new DBOpenHelper(this,"test.db",null,1); SQLiteDatabase db = helper.getWritableDatabase(); //根据画面上输入的账号/密码去数据库中进行查询(user是表名) Cursor c = db.query("user",null,"name=? and pwd=?",new String[]{name.getText().toString(),pwd.getText().toString()},null,null,null); //如果有查询到数据 if(c!=null && c.getCount() >= 1){ Toast.makeText(this, "输入正确!", Toast.LENGTH_SHORT).show(); //可以把查询出来的值打印出来在后台显示/查看 String[] cols = c.getColumnNames(); while(c.moveToNext()){ for(String ColumnName:cols){ Log.i("info",ColumnName+":"+c.getString(c.getColumnIndex(ColumnName))); } } c.close(); db.close(); this.finish(); } //如果没有查询到数据 else{ Toast.makeText(this, "输入错误!", Toast.LENGTH_SHORT).show(); }}
|